Clinical Trial ROA Analyzer with Claude AI Integration
Published on Apr 01 2024 by Avinash Veerella

Client: Global Data
Role: Senior Software Developer
Skills used: C# 13, NET Console Application (ASP.NET Core / .NET 8), Anthropic API, Amazon SES, Windows Scheduler.
Tools used: Visual Studio 2022, SQL Server Management Studio 19.
Description
Developed a scalable, high-performance clinical trial analytics system that integrates Anthropic’s Claude AI to extract and standardize routes of administration (ROA) from over 600,000 unstructured clinical trial records. Focused on cost-efficiency, system reliability, and data accuracy for pharmaceutical intelligence.
Responsibilities
- Engineered a high-performance batch processing system that analyzed 600,000+ clinical trials in 10 days, extracting drug administration data with exceptional accuracy.
- Reduced project costs by 67% through implementation of Anthropic’s batch API, bringing expenses down from $8,500 to $2,800.
- Developed an intelligent NLP pipeline that extracted and standardized drug administration routes from unstructured clinical descriptions.
- Optimized SQL database operations with parameterized stored procedures and bulk operations for efficient data processing.
- Implemented automated monitoring with email reporting to provide stakeholders with real-time processing metrics.